﻿<%@ Page Title="" Language="C#" MasterPageFile="MasterPage.master" AutoEventWireup="true" CodeFile="DadosInscrito.aspx.cs" Inherits="_DadosInscrito" %>
<%@ Register assembly="DevExpress.Web.ASPxGridView.v9.1, Version=9.1.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxGridView" tagprefix="dxwgv" %>
<%@ Register assembly="DevExpress.Web.ASPxEditors.v9.1, Version=9.1.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxEditors" tagprefix="dxe" %>
<%@ Register assembly="DevExpress.Web.v9.1, Version=9.1.3.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" namespace="DevExpress.Web.ASPxClasses" tagprefix="dxw" %>


<%@ Register assembly="DevExpress.Web.ASPxEditors.v9.1" namespace="DevExpress.Web.ASPxEditors" tagprefix="dxe" %>
<%@ Register assembly="DevExpress.Web.ASPxGridView.v9.1" namespace="DevExpress.Web.ASPxGridView" tagprefix="dxwgv" %>


<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
    <style type="text/css">
    #tabela 
    {
       font: 18px tahoma, arial;
    }
    .tabela2 
    {
       padding: 10px;
    }
    .descricao 
    {
        width: 345px;
    }
    select
    {
        margin-top: 5px;
        font: 12px tahoma, arial;
        padding: 2px;
    }
    .nome 
    {
        font: bold 20px Tahoma, Arial;
        color: #006C91;
    }

    img 
    {
        border: none;
    }
            
    #capacitacao, #aperfeicoamento, #informatica, #idioma, #ativComplementares, #aprendiz, #experiencia
    {
        width: 434px; 
        min-height: 70px;
        padding-left: 50px;
        padding-bottom: 5px;
    }
    
    #outrasCapacitacoes 
    {
        margin-top:10px;
    }

    #capacitacao 
    {
        background:url(../figuras/sLaranja.gif) no-repeat left top;
    }

    #aperfeicoamento
    {
        background:url(../figuras/sAzul.gif) no-repeat left top;
    }
    #experiencia 
    {
        background:url(../figuras/sVermelho.gif) no-repeat left top;
    }
    #informatica
    {
        background:url(../figuras/sLilas.gif) no-repeat left top;
    }
    #idioma
    {
        background:url(../figuras/sRosa.gif) no-repeat left top;
    }
    #ativComplementares
    {
        background:url(../figuras/sVerde.gif) no-repeat left top;
    }
    #aprendiz
    {
        background:url(../figuras/sCinza.gif) no-repeat left top;
    }
    .cursos 
    {
        font: bold 12px arial;
        margin-left: 10px;
        margin-top: 3px;
        line-height: 20px;
        background-color: #E9E9E9;
    }
    .cursos td {background-color: #E9E9E9; }
    .cursos td.dxgv {width: 392px;}
    .cursos td.dxgvDetailCell  
    {
        padding: 8px 0 8px 6px;
        text-align: justify;
    }
    
    #conteudo1, #conteudo2, #conteudo3
    {
        font: bold 11px arial;
    }
    </style>

</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<script type="text/javascript">muda(curriculo, '#0C5C7E');</script>
<div id="icones" class="naoimprimir">
    <a href="javascript:window.print();"><img src="../figuras/icoImpressora.gif" title="Imprimir currículo" /></a>
</div>
<table style="width:494px;margin-top:10px;" cellpadding="0" cellspacing="4" id="tabela">
<tr>
    <td colspan="2"><asp:Label ID="lblNome" runat="server" CssClass="nome"></asp:Label></td>
</tr>
<tr>
    <td colspan="2" style="height:5px;">
        <asp:Label ID="lblMensagem" runat="server" ForeColor="Red"></asp:Label>
    </td>
</tr>
<tr>
    <td style="width:110px;">Endereço:</td>
    <td align="left" class="descricao" style="width:384px;"><asp:Label ID="lblEndereco" runat="server" EnableViewState="False"></asp:Label>
        <asp:HiddenField ID="hfCPF" runat="server" />
        <asp:HiddenField ID="hfCodInscrito" runat="server" />
    </td>
</tr>
<tr>
    <td style="width:110px;">Telefone:</td>
    <td align="left" class="descricao"><asp:Label ID="lblTelefone" runat="server"></asp:Label></td>
</tr>    
<tr>
    <td style="width:110px;">Email:</td>
    <td class="descricao"><asp:Label ID="lblEmail" runat="server"></asp:Label></td>
</tr>
<tr>
    <td style="width:110px;">Nascimento:</td>
    <td class="descricao"><asp:Label ID="lblDataNascimento" runat="server"></asp:Label></td>
</tr>
<tr>
    <td style="width:110px;">Estado Civil:</td>
    <td class="descricao">
        <table cellpadding="0" cellspacing="0" style="width:100%;">
            <tr>
                <td>
                    <asp:Label ID="lblEstadoCivil" runat="server"></asp:Label>
                </td>
                <td align="right">
                    Sexo:&nbsp;</td>
                <td>
    <asp:Label ID="lblSexo" runat="server" EnableViewState="False"></asp:Label>
                </td>
            </tr>
        </table>
    </td>
</tr>
<tr>
    <td style="width:110px;">Escolaridade:</td>
    <td class="descricao"><asp:Label ID="lblEscolaridade" runat="server"></asp:Label></td>
</tr>

        <tr><td colspan="2" style="height:5px;"></td></tr>
        <tr><td colspan="2">

        <asp:Panel ID="pnlCapacitacao" runat="server" Visible="false">                       
        <div id="capacitacao">
            Capacitação <img src="../figuras/seloCamara.gif" title="Certificado pelo Shopping Camará" /> <img src="../figuras/seloSENAC.gif" title="Certificado pelo SENAC Pernambuco" />
            <dxwgv:aspxgridview ID="gridCapacitacao" ClientInstanceName="gridCapacitacao" runat="server" 
                DataSourceID="dsCapacitacao" KeyFieldName="CodCurso" Width="420px" SettingsLoadingPanel-Text="Carregando&hellip;" Settings-ShowGroupButtons="False" Settings-ShowColumnHeaders="false" CssClass="cursos" Border-BorderStyle="None" SettingsText-EmptyDataRow="&nbsp;">
             <Columns>
                <dxwgv:GridViewDataColumn FieldName="Curso" VisibleIndex="0" CellStyle-BackColor="#E9E9E9">
                <DataItemTemplate>
                    <asp:Label ID="Label1" runat="server" Text=<%# String.Format("{0} - {1} horas", Eval("Curso"), Eval("CH"))%>></asp:Label>
                </DataItemTemplate>
                </dxwgv:GridViewDataColumn>            
             </Columns>
             <Templates>
                <DetailRow>
                     <%# Eval("DescricaoParcial")%>
                </DetailRow>
             </Templates>
            <SettingsDetail ShowDetailRow="true"/>                
            </dxwgv:aspxgridview>
            <asp:SqlDataSource ID="dsCapacitacao" runat="server" 
                ConnectionString="<%$ ConnectionStrings:conexao_intranet_ler %>" 
                ProviderName="<%$ ConnectionStrings:conexao_intranet_ler.ProviderName %>" 
                
                SelectCommand="SELECT RioMarCursos.CodCurso, RioMarCursos.Curso, RioMarCursos.CH, RioMarCursos.DescricaoParcial FROM RioMarInscritosCursos INNER JOIN RioMarCursos ON RioMarInscritosCursos.CodCurso = RioMarCursos.CodCurso WHERE (RioMarInscritosCursos.CPF = @cpf) AND (RioMarCursos.CodCategoria = 1)">
                <SelectParameters>
                    <asp:SessionParameter SessionField="cpf" Name="cpf" />
                </SelectParameters>
            </asp:SqlDataSource>

        </div>
        </asp:Panel>

        <asp:Panel ID="pnlAperf" runat="server" Visible="false">                       
        <div id="aperfeicoamento">
            Aperfeiçoamento <img src="../figuras/seloCamara.gif" title="Certificado pelo Shopping Camará" /> <img src="../figuras/seloSENAC.gif" title="Certificado pelo SENAC Pernambuco" />



            <dxwgv:aspxgridview ID="gridAperf" ClientInstanceName="gridAperf" runat="server" 
                DataSourceID="dsAperfeicoamento" KeyFieldName="CodCurso" Width="420px" SettingsLoadingPanel-Text="Carregando&hellip;" Settings-ShowGroupButtons="False" Settings-ShowColumnHeaders="false" CssClass="cursos" Border-BorderStyle="None" SettingsText-EmptyDataRow="&nbsp;">
             <Columns>
                <dxwgv:GridViewDataColumn FieldName="Curso" VisibleIndex="0" CellStyle-BackColor="#E9E9E9">
                <DataItemTemplate>
                    <asp:Label ID="Label1" runat="server" Text=<%# String.Format("{0} - {1} horas", Eval("Curso"), Eval("CH"))%>></asp:Label>
                </DataItemTemplate>
                </dxwgv:GridViewDataColumn>            
             </Columns>
             <Templates>
                <DetailRow>
                     <%# Eval("DescricaoParcial")%>
                </DetailRow>
             </Templates>
            <SettingsDetail ShowDetailRow="true"/>                
            </dxwgv:aspxgridview>
            <asp:SqlDataSource ID="dsAperfeicoamento" runat="server" 
                ConnectionString="<%$ ConnectionStrings:conexao_intranet_ler %>" 
                ProviderName="<%$ ConnectionStrings:conexao_intranet_ler.ProviderName %>" 
                SelectCommand="SELECT RioMarCursos.CodCurso, RioMarCursos.CH, RioMarCursos.Curso, RioMarCursos.DescricaoParcial FROM RioMarInscritosCursos INNER JOIN RioMarCursos ON RioMarInscritosCursos.CodCurso = RioMarCursos.CodCurso WHERE (RioMarInscritosCursos.CPF = @cpf) AND (RioMarCursos.CodCategoria = 2)">
                <SelectParameters>
                    <asp:SessionParameter SessionField="cpf" Name="cpf" />
                </SelectParameters>    
            </asp:SqlDataSource>




        </div>   
        </asp:Panel>  
        

        <asp:Panel ID="pnlInformatica" runat="server" Visible="false">
        <div id="informatica">
        Informática <img src="../figuras/seloCamara.gif" title="Certificado pelo Shopping Camará" /> <img src="../figuras/seloSENAC.gif" title="Certificado pelo SENAC Pernambuco" />
        
        
             <dxwgv:aspxgridview ID="gridInformatica" ClientInstanceName="gridInformatica" runat="server" 
                DataSourceID="dsAlfEcologica" KeyFieldName="CodCurso" Width="420px" SettingsLoadingPanel-Text="Carregando&hellip;" Settings-ShowGroupButtons="False" Settings-ShowColumnHeaders="false" CssClass="cursos" Border-BorderStyle="None" SettingsText-EmptyDataRow="&nbsp;">
             <Columns>
                <dxwgv:GridViewDataColumn FieldName="Curso" VisibleIndex="0" CellStyle-BackColor="#E9E9E9">
                <DataItemTemplate>
                    <asp:Label ID="Label1" runat="server" Text=<%# String.Format("{0} - {1} horas", Eval("Curso"), Eval("CH"))%>></asp:Label>
                </DataItemTemplate>
                </dxwgv:GridViewDataColumn>            
             </Columns>
             <Templates>
                <DetailRow>
                     <%# Eval("DescricaoParcial")%>
                </DetailRow>
             </Templates>
            <SettingsDetail ShowDetailRow="true"/>                
            </dxwgv:aspxgridview>
            <asp:SqlDataSource ID="dsAlfEcologica" runat="server" 
                ConnectionString="<%$ ConnectionStrings:conexao_intranet_ler %>" 
                ProviderName="<%$ ConnectionStrings:conexao_intranet_ler.ProviderName %>" 
                SelectCommand="SELECT RioMarCursos.CodCurso, RioMarCursos.CH, RioMarCursos.Curso, RioMarCursos.DescricaoParcial FROM RioMarInscritosCursos INNER JOIN RioMarCursos ON RioMarInscritosCursos.CodCurso = RioMarCursos.CodCurso WHERE (RioMarInscritosCursos.CPF = @cpf) AND (RioMarCursos.CodCategoria = 4)">
                <SelectParameters>
                    <asp:SessionParameter SessionField="cpf" Name="cpf" />
                </SelectParameters>
            </asp:SqlDataSource>

        
        
        
        </div>
        </asp:Panel>

        <asp:Panel ID="pnlIdiomas" runat="server" Visible="false">                       
        <div id="idioma">
        Idiomas <img src="../figuras/seloCamara.gif" title="Certificado pelo Shopping Camará" /> <img src="../figuras/seloSENAC.gif" title="Certificado pelo SENAC Pernambuco" />
                
             <dxwgv:aspxgridview ID="gridIdioma" ClientInstanceName="gridIdioma" runat="server" 
                DataSourceID="dsIdioma" KeyFieldName="CodCurso" Width="420px" SettingsLoadingPanel-Text="Carregando&hellip;" Settings-ShowGroupButtons="False" Settings-ShowColumnHeaders="false" CssClass="cursos" Border-BorderStyle="None" SettingsText-EmptyDataRow="&nbsp;">
             <Columns>
                <dxwgv:GridViewDataColumn FieldName="Curso" VisibleIndex="0" CellStyle-BackColor="#E9E9E9">
                <DataItemTemplate>
                    <asp:Label ID="Label1" runat="server" Text=<%# String.Format("{0} - {1} horas", Eval("Curso"), Eval("CH"))%>></asp:Label>
                </DataItemTemplate>
                </dxwgv:GridViewDataColumn>            
             </Columns>
             <Templates>
                <DetailRow>
                     <%# Eval("DescricaoParcial")%>
                </DetailRow>
             </Templates>
            <SettingsDetail ShowDetailRow="true"/>                
            </dxwgv:aspxgridview>
            <asp:SqlDataSource ID="dsIdioma" runat="server" 
                ConnectionString="<%$ ConnectionStrings:conexao_intranet_ler %>" 
                ProviderName="<%$ ConnectionStrings:conexao_intranet_ler.ProviderName %>" 
                SelectCommand="SELECT RioMarCursos.CodCurso, RioMarCursos.CH, RioMarCursos.Curso, RioMarCursos.DescricaoParcial FROM RioMarInscritosCursos INNER JOIN RioMarCursos ON RioMarInscritosCursos.CodCurso = RioMarCursos.CodCurso WHERE (RioMarInscritosCursos.CPF = @cpf) AND (RioMarCursos.CodCategoria = 5)">
                
                <SelectParameters>
                    <asp:SessionParameter SessionField="cpf" Name="cpf" />
                </SelectParameters>
    
            </asp:SqlDataSource>

        
        
        </div>
        </asp:Panel>

        <asp:Panel ID="pnlAtivComplementares" runat="server" Visible="false">
        <div id="ativComplementares">
        Atividades Complementares <img src="../figuras/seloCamara.gif" title="Certificado pelo Shopping Camará" /> <img src="../figuras/seloSENAC.gif" title="Certificado pelo SENAC Pernambuco" />
        
        
             <dxwgv:aspxgridview ID="gridAtivComplementares" ClientInstanceName="gridAtivComplementares" runat="server" 
                DataSourceID="dsConComplementares" KeyFieldName="CodCurso" Width="420px" SettingsLoadingPanel-Text="Carregando&hellip;" Settings-ShowGroupButtons="False" Settings-ShowColumnHeaders="false" CssClass="cursos" Border-BorderStyle="None" SettingsText-EmptyDataRow="&nbsp;">
             <Columns>
                <dxwgv:GridViewDataColumn FieldName="Curso" VisibleIndex="0" CellStyle-BackColor="#E9E9E9">
                <DataItemTemplate>
                    <asp:Label ID="Label1" runat="server" Text=<%# String.Format("{0} - {1} horas", Eval("Curso"), Eval("CH"))%>></asp:Label>
                </DataItemTemplate>
                </dxwgv:GridViewDataColumn>            
             </Columns>
             <Templates>
                <DetailRow>
                     <%# Eval("DescricaoParcial")%>
                </DetailRow>
             </Templates>
            <SettingsDetail ShowDetailRow="true"/>                
            </dxwgv:aspxgridview>
            <asp:SqlDataSource ID="dsConComplementares" runat="server" 
                ConnectionString="<%$ ConnectionStrings:conexao_intranet_ler %>" 
                ProviderName="<%$ ConnectionStrings:conexao_intranet_ler.ProviderName %>" 
                SelectCommand="SELECT RioMarCursos.CodCurso, RioMarCursos.CH, RioMarCursos.Curso, RioMarCursos.DescricaoParcial FROM RioMarInscritosCursos INNER JOIN RioMarCursos ON RioMarInscritosCursos.CodCurso = RioMarCursos.CodCurso WHERE (RioMarInscritosCursos.CPF = @cpf) AND (RioMarCursos.CodCategoria = 6)">
                <SelectParameters>
                    <asp:SessionParameter SessionField="cpf" Name="cpf" />
                </SelectParameters>    
            </asp:SqlDataSource>        
        
        </div>
        </asp:Panel>

        <asp:Panel ID="pnlAprendiz" runat="server" Visible="false">
        <div id="aprendiz">
        Aprendiz <img src="../figuras/seloCamara.gif" title="Certificado pelo Shopping Camará" /> <img src="../figuras/seloSENAC.gif" title="Certificado pelo SENAC Pernambuco" />
        
             <dxwgv:aspxgridview ID="gridAprendiz" ClientInstanceName="gridAprendiz" runat="server" 
                DataSourceID="dsAprendiz" KeyFieldName="CodCurso" Width="420px" SettingsLoadingPanel-Text="Carregando&hellip;" Settings-ShowGroupButtons="False" Settings-ShowColumnHeaders="false" CssClass="cursos" Border-BorderStyle="None" SettingsText-EmptyDataRow="&nbsp;">
             <Columns>
                <dxwgv:GridViewDataColumn FieldName="Curso" VisibleIndex="0" CellStyle-BackColor="#E9E9E9">
                <DataItemTemplate>
                    <asp:Label ID="Label1" runat="server" Text=<%# String.Format("{0} - {1} horas", Eval("Curso"), Eval("CH"))%>></asp:Label>
                </DataItemTemplate>
                </dxwgv:GridViewDataColumn>            
             </Columns>
             <Templates>
                <DetailRow>
                     <%# Eval("DescricaoParcial")%>
                </DetailRow>
             </Templates>
            <SettingsDetail ShowDetailRow="true"/>                
            </dxwgv:aspxgridview>
            <asp:SqlDataSource ID="dsAprendiz" runat="server" 
                ConnectionString="<%$ ConnectionStrings:conexao_intranet_ler %>" 
                ProviderName="<%$ ConnectionStrings:conexao_intranet_ler.ProviderName %>" 
                SelectCommand="SELECT RioMarCursos.CodCurso, RioMarCursos.CH, RioMarCursos.Curso, RioMarCursos.DescricaoParcial FROM RioMarInscritosCursos INNER JOIN RioMarCursos ON RioMarInscritosCursos.CodCurso = RioMarCursos.CodCurso WHERE (RioMarInscritosCursos.CPF = @cpf) AND (RioMarCursos.CodCategoria = 8)">
                <SelectParameters>
                    <asp:SessionParameter SessionField="cpf" Name="cpf" />
                </SelectParameters>                
            </asp:SqlDataSource>
        

        
        </div>
        </asp:Panel>


        <asp:Panel ID="pnlExperiencia" runat="server" Visible="false">   
        <div id="experiencia">
        Experiência Profissional
        
        
            <dxwgv:aspxgridview ID="gridExperiencia" ClientInstanceName="gridExperiencia" runat="server" 
                DataSourceID="dsExperiencia" KeyFieldName="CPF" Width="420px" SettingsLoadingPanel-Text="Carregando&hellip;" Settings-ShowGroupButtons="False" Settings-ShowColumnHeaders="false" CssClass="cursos" Border-BorderStyle="None" SettingsText-EmptyDataRow="&nbsp;">
             <Columns>
                <dxwgv:GridViewDataColumn FieldName="Experiencia" VisibleIndex="0" CellStyle-BackColor="#E9E9E9">
                    <DataItemTemplate>
                        <asp:Label ID="Label1" runat="server" Text=<%# String.Format("{0} - {1} - {2}", Eval("Funcao"), Eval("Local"), Eval("Tempo"))%>></asp:Label>
                    </DataItemTemplate>
                </dxwgv:GridViewDataColumn>               
             </Columns>
            </dxwgv:aspxgridview>
            <asp:SqlDataSource ID="dsExperiencia" runat="server" 
                ConnectionString="<%$ ConnectionStrings:conexao_intranet_ler %>" 
                ProviderName="<%$ ConnectionStrings:conexao_intranet_ler.ProviderName %>" 
                SelectCommand="SELECT RiomarFuncoes.Funcao, RiomarInscritosExperiencias.Local, RiomarInscritosExperiencias.Tempo
FROM RiomarFuncoes INNER JOIN RiomarInscritosExperiencias ON RiomarFuncoes.CodFuncao = RiomarInscritosExperiencias.CodFuncao WHERE (RiomarInscritosExperiencias.CPF = @cpf)">
                <SelectParameters>
                    <asp:SessionParameter SessionField="cpf" Name="cpf" />
                </SelectParameters>
            </asp:SqlDataSource>
                
        
        </div>
        </asp:Panel>




        <asp:Panel ID="pnlOutrasCapacitacoes" runat="server" Visible="false">   
        <div id="outrasCapacitacoes">
        Outras qualificações informadas pelo candidato
        
        
            <dxwgv:aspxgridview ID="gridOutrasCapacitacoes" ClientInstanceName="gridOutrasCapacitacoes" runat="server" 
                DataSourceID="dsOutrasCapacitacoes" KeyFieldName="CPF" Width="420px" SettingsLoadingPanel-Text="Carregando&hellip;" Settings-ShowGroupButtons="False" Settings-ShowColumnHeaders="false" CssClass="cursos" Border-BorderStyle="None" SettingsText-EmptyDataRow="&nbsp;">
             <Columns>
                <dxwgv:GridViewDataColumn FieldName="Curso" VisibleIndex="0" CellStyle-BackColor="#E9E9E9">
                <DataItemTemplate>
                    <asp:Label ID="Label1" runat="server" Text=<%# String.Format("{0} - {1} horas - {2}", Eval("Curso"), Eval("CH"), Eval("Instituicao"))%>></asp:Label>
                </DataItemTemplate>
                </dxwgv:GridViewDataColumn>            
             </Columns>
            </dxwgv:aspxgridview>
            <asp:SqlDataSource ID="dsOutrasCapacitacoes" runat="server" 
                ConnectionString="<%$ ConnectionStrings:conexao_intranet_ler %>" 
                ProviderName="<%$ ConnectionStrings:conexao_intranet_ler.ProviderName %>" 
                SelectCommand="SELECT * FROM RiomarInscritosOutrasCapacitacoes WHERE CPF = @cpf ORDER BY Curso">
                <SelectParameters>
                    <asp:SessionParameter SessionField="cpf" Name="cpf" />
                </SelectParameters>
            </asp:SqlDataSource>
                
        
        </div>
        </asp:Panel>




        </td></tr>
        </table>
        </asp:Content>